How to: Print a datasheet for a table, query, or form.
Solution:
To print the entire datasheet, open the datasheet, and use the 'Print' command under the 'File' menu. To print selected records only, open the datasheet, select the desired records, use the 'Print' command under the 'File' menu, and select the 'Selected Record(s)' radio button.
Do one of the following:
NOTE: If the Database window is not active, activate the Database window.
1) To print the entire datasheet:
2) To print selected records only:
a) Open the datasheet for the desired object.
b) Select the desired record or records by clicking on the 'Row Selector' for each record.
Row Selector
NOTE: To select more than one adjacent record, press and hold down SHIFT while clicking on each 'Row Selector'. To select more than one non-adjacent record, press and hold down CTRL while clicking on each 'Row Selector'.
c) Select the 'File' menu and select 'Print...' (The Print dialog box appears.)
Print dialog box
d) Select the 'Selected Record(s)' radio button.
e) Make any other desired selections.
f) Click 'OK'.